package jdbc;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {
    public static void main(String[] args) {
        UserInfo userInfo = InputUtil.getInputObject(new UserInfo(), "删除用户", "删除");
        System.out.println(userInfo);
        try (
            Connection connection = DBUtil.getConnection();)
            {
                Statement statement = connection.createStatement();
                String sql = "DELETE from userinfo " +
                        "where username ='" + userInfo.getUsername() + "'";
                System.out.println(sql);
                int num = statement.executeUpdate(sql);
                System.out.println("删除" + (num > 0 ? "成功" : "失败"));
            } catch(Exception e){
                throw new RuntimeException(e);
            }
        }
    }
